CREATE TABLE IF NOT EXISTS categories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO categories (name, description) VALUES
('Analgesics', 'Pain relievers, e.g. paracetamol, ibuprofen'),
('Antibiotics', 'Bacterial infection treatments, e.g. amoxicillin, cephalexin'),
('Antihistamines', 'Allergy relief, e.g. cetirizine, loratadine'),
('Antipyretics', 'Fever reducers, e.g. paracetamol'),
('Antacids', 'Acidity and heartburn relief, e.g. antacid tablets, omeprazole'),
('Antidiarrheals', 'Diarrhea treatment, e.g. loperamide'),
('Antifungals', 'Fungal infection treatment, e.g. clotrimazole, fluconazole'),
('Antivirals', 'Viral infection treatment, e.g. oseltamivir, acyclovir'),
('Antihypertensives', 'Blood pressure control, e.g. amlodipine, losartan'),
('Antidiabetics', 'Blood sugar control, e.g. metformin, gliclazide'),
('Cardiovascular', 'Heart and circulation drugs, e.g. statins, beta-blockers'),
('Respiratory / Cough & Cold', 'Cough, cold, and asthma relief, e.g. salbutamol, dextromethorphan'),
('Vitamins & Supplements', 'Multivitamins, minerals, dietary supplements'),
('Gastrointestinal', 'Digestive system medicine, e.g. laxatives, antispasmodics'),
('Dermatological', 'Skin treatments, e.g. creams, ointments, antiseptics'),
('Ophthalmic', 'Eye drops and eye ointments'),
('ENT (Ear, Nose, Throat)', 'Ear drops, nasal sprays, throat lozenges'),
('Contraceptives', 'Birth control pills and related products'),
('Psychotropics / Controlled Substances', 'Regulated drugs requiring special handling, e.g. benzodiazepines, opioids'),
('Herbal / Alternative Medicine', 'Herbal supplements and traditional remedies'),
('Pediatric', 'Medicines formulated for children'),
('First Aid / Medical Supplies', 'Bandages, antiseptics, syringes, thermometers, etc.');